How to: Export a table or query to a delimited or fixed-width text file.
Solution:
Use the 'Save As/Export...' command in the 'File' menu, specify the 'Text Files (*.txt)' file type and a name and location for the exported file, and click 'Export'. Then follow the instructions displayed by the Text Export Wizard.
NOTE: Exported text files do not preserve any formatting. To keep the datasheet's font and other formatting, export all or a portion of the table or query as a Rich Text Format file.
1) Open the desired database.
2) If the Database window is not active, activate the Database window.
3) In the Database window, click the appropriate tab.
4) Select the table or query to export.
5) Select the 'File' menu and select 'Save As/Export...'. (The Save As... dialog box appears.)
6) Select the 'To an external File or Database' radio button.
the To an external File or Database radio button
7) Click 'OK'. (The Save <Object> <Object Name> In dialog box appears, where <Object> is the selected object type and <Object Name> is the name of the selected object.)
8) Select 'Text Files (*.txt, *.csv, *.tab, *.asc )' from the 'Save as type' drop-down list box.
Selecting the Text file type
9) Select the drive where the exported text file is to be stored from the 'Save in' drop-down list.
10) Select the specific folder in which to store the text file from the 'Save in' drop-down list box.
NOTE: If the text file is to be stored to a subfolder, continue selecting folders until the desired folder is displayed in the 'Save in' drop-down list box.
11) Do one of the following:
a) Type a name for the file in the 'File name' text box.
b) Accept the name suggested by Access.
12) Click 'Export'. (The 'Text Export Wizard' dialog box appears.)
Specifying the exported file format
13) Do one of the following to specify the format of the exported data:
14) Click 'Next'.
15) If the 'Delimited' radio button is selected in Step 13):
a) Select the delimiter to use to separate the fields.
b) (Optional) Select the 'Include Field Name on First Row' check box.
Exporting a delimited text file
16) If the 'Fixed Width' radio button is selected in Step 13), move the arrow lines to adjust the space between text columns.
Exporting a fixed-width text file
17) Click 'Next'.
18) Do one of the following in the 'Export to File' box:
a) Type a new filename for the exported text file.
b) Accept the name suggested by Access.
the Export to File box
19) Click 'Finish' to start the text export process.
20) Click 'OK' when the export is complete.
